package com.zkyc.framework.common.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zkyc.framework.common.pojo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author bing.bai
 * @create 2022/5/24
 */
@Mapper
public interface SystemLogMapper extends BaseMapper<SystemLog> {

    @Select("select * from system_user where id = #{id} and is_deleted = 0")
    User selectUser(String id);

    @Select("select * from system_role where id = #{id} and is_deleted = 0")
    Role selectRole(String id);

    @Select("select * from web_website where id = #{id} and is_deleted = 0")
    Website selectWebsite(String id);

    @Select("select * from web_association where id = #{id} and is_deleted = 0")
    Association selectAssociation(String id);

    @Select("select * from web_activity where id = #{id} and is_deleted = 0")
    Activity selectActivity(String id);
}
